
/****** Object:  Table [dbo].[BuildDetail4Log]    Script Date: 12/06/2011 23:04:47 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[BuildDetail4Log](
	[BuildDetailId] [bigint] NOT NULL,
	[EntDate] [datetime] NOT NULL,
	[BuildId] [bigint] NOT NULL,
	[ItemCode] [nvarchar](50) NOT NULL,
	[ItemName] [nvarchar](255) NOT NULL,
	[Unit] [nvarchar](50) NOT NULL,
	[Quantity] [float] NOT NULL,
	[BuyPrice] [money] NOT NULL,
	[Price] [money] NOT NULL,
	[Discount] [money] NOT NULL,
	[DiscountOnItemId] [bigint] NULL,
	[VAT] [int] NOT NULL,
	[TotalPrice] [money] NOT NULL,
	[GrpMaterialId] [bigint] NOT NULL,
	[TypeMaterialId] [bigint] NOT NULL,
	[TradeMaterialId] [bigint] NOT NULL,
	[UserId] [bigint] NOT NULL,
	[CounterId] [bigint] NOT NULL,
	[Note] [nvarchar](50) NOT NULL,
	[PromotionServiceId] [bigint] NULL,
	[PromotionType] [bit] NOT NULL,
	[PromotionBuildDetailId] [bigint] NULL,
	[ItemType] [int] NOT NULL,
	[ClientCode] [nvarchar](255) NOT NULL,
	[SyncCode] [nvarchar](255) NOT NULL,
	[TimeStamp] [timestamp] NOT NULL,
	[BuildNumber] [nvarchar](255) NULL,
	[TimeStampCode] [varbinary](8) NULL,
	[LogType] [nvarchar](255) NULL,
	[LogDate] [datetime] NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


